"VER1.0","Articulos","Listado de articulos por famlias"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
0, 0, 0
0, 0, 0, 0
; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT * , CodigoPostal & ' - ' & Poblacion as Direc, 'Tel : ' & Telefono1 as Tel "
"FROM Configuracion"
""
[CAPSALERA]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
3,"CABECERA","NombreComercial",10,5,"ARIAL",12,0,0,"1000",""
0,"Condiciones : ",10,20,"ARIAL",8,0,0,"1000"
6,"Condiciones",35,20,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Nif",10,20,"ARIAL",10,0,0,"1000",""
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
[FIPEU]
[FIGRUP]

;-----------------------------------------


; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 27, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 13
0,"Estadstica Ventas por Articulo", 45, 1,"ARIAL",16,0,0,"1000"
0,"Pgina :",170,0,"ARIAL",8,0,0,"1000"
6,"Pagina",195,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",170,5,"ARIAL",8,0,0,"1000"
6,"Fecha",195,5,"ARIAL",8,0,1,"1000",""
1,"linea2", 3, 19, 197, 19,,,
0,"Codigo",5,20,"ARIAL",8,0,0,"1000"
0,"Descripcin",30,20,"ARIAL",8,0,0,"1000"
0,"Unidades", 152,20,"ARIAL",8,0,1,"1000"
0,"Cajas", 165,20,"ARIAL",8,0,1,"1000"
0,"P.Medio",177,20,"ARIAL",8,0,1,"1000"
0,"Valor",195,20,"ARIAL",8,0,1,"1000"
1,"linea1", 3, 24, 197, 24,,,
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
1, "Cuadro", 40, 0, 197, 8, 1, 0,
0,"Totales Generales :", 50,2.5,"ARIAL",12,0,0,"1000"
5,0,"TotalG", 195,3,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

;-----------------------------------------


;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT CodFamilia & ' - ' & Descripcion as Titulo2, * "
"FROM Familias"
""
[ORDENACIONS] 1
"CodFamilia", "Codigo Familia", 3

[CONDICIONS] 1
"CodFamilia", "Cod. Familia", 0, 1

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB1","Titulo2",5,0,"ARIAL",10,0,0,"1001",""
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
;0,"Totales :",50,0,"ARIAL",10,0,0,"0000"
[CAMPS] 3
1, "lineaH3",182, 0, 197,0,,,
8, "0", "'Totales Familia ' + Campo('CAB1','CodFamilia') + ' :' ", 50, 2, "ARIAL", 9, 0, 0, "1000", ""
5,0,"TotalF", 195,2,"ARIAL",9,0,1,"1000","Total"
[FIPEU]
[FIGRUP]


;tipo, NomGrup, Select, From, GropBy
;VenAlbaLin.CodArticulo, VenAlbaLin.Seccion, 
[GRUP]
3,"COS", #FALSE#
"SELECT Articulos.CodArticulo, First(Articulos.CodFamilia) AS CodFamilia, First(Articulos.Descripcion) AS Descripcion, First(Articulos.UnidadBulto) AS UnidadBulto, Sum(VenAlbaLin.Cantidad) AS TCantidad, Sum(VenAlbaLin.Total) AS TValor, TValor/TCantidad AS PrecioMedio "
"FROM (VenAlbaLin INNER JOIN VenAlba ON (VenAlbaLin.CodCliente = VenAlba.CodCliente) AND (VenAlbaLin.NumAlbaran = VenAlba.NumAlbaran) AND (VenAlbaLin.Seccion = VenAlba.Seccion)) INNER JOIN Articulos ON VenAlbaLin.CodArticulo = Articulos.CodArticulo "
"GROUP BY Articulos.CodArticulo"

[ORDENACIONS] 1
"Articulos.CodArticulo", "Codigo Articulo", 3

[CONDICIONS] 5
"CodFamilia", "CodFamilia", 1, 1, "CAB1", "CodFamilia"
" VenAlbaLin.Seccion","Seccion",0,1
" VenAlba.FechaFactura","Fecha Periodo",0,2
" (VenAlbaLin.CodAlmacen <> '2') ","",4
" VenAlba.CodRepresentante","Representante",0,1

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
3, "COS", "CodArticulo", 5, 0, "ARIAL", 8, 0, 0, "0000", ""
3, "COS", "Descripcion", 20, 0, "ARIAL", 8, 125, 0, "0000", ""
3, "COS", "TCantidad", 152,0,"ARIAL",8,0,1,"0000",""
8, "1", "CAJAS( Campo('COS','TCantidad'), Campo('COS','UnidadBulto'), Campo('COS','TValor')) ", 165, 0, "ARIAL", 8, 0, 1, "0000", "###,###;;\ ---"
3, "COS", "PrecioMedio", 177,0,"ARIAL",8,0,1,"0000","Precio"
3, "COS", "TValor", 195,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 2
"TotalF","COS","TValor","CAB1"
"TotalG","COS","TValor","GENERAL"

[FIDOCUM]


